home *** CD-ROM | disk | FTP | other *** search
/ Archive Magazine CD 1995 / Archive Magazine CD 1995.iso / discs / pipeline / 4_01 / Fry / Electric < prev    next >
Encoding:
Text File  |  1990-07-28  |  21.8 KB  |  993 lines
  1. %OP%TM2
  2. %OP%HM0
  3. %OP%FM0
  4. %OP%BM0
  5. %OP%LM10
  6. %OP%FR0,5
  7. %CO:A,9,93%%C% Electricity Consumption at Noddy's House - since 27 Nov 1975
  8.  
  9. Reading
  10. Date
  11.  
  12. %V%%R%27.11.75
  13. %V%%R%25.2.76
  14. %V%%R%25.5.76
  15. %V%%R%24.8.76
  16. %V%%R%22.11.76
  17. %V%%R%22.2.77
  18. %V%%R%23.5.77
  19. %V%%R%25.8.77
  20. %V%%R%23.11.77
  21. %V%%R%24.2.78
  22. %V%%R%24.5.78
  23. %V%%R%29.8.78
  24. %V%%R%28.11.78
  25. %V%%R%26.2.79
  26. %V%%R%22.5.79
  27. %V%%R%21.8.79
  28. %V%%R%19.11.79
  29. %V%%R%20.2.80
  30. %V%%R%27.5.80
  31. %V%%R%27.8.80
  32. %V%%R%20.11.80
  33. %V%%R%24.2.81
  34. %V%%R%21.5.81
  35. %V%%R%25.8.81
  36. %V%%R%18.11.81
  37. %V%%R%1.3.82
  38. %V%%R%26.5.82
  39. %V%%R%27.8.82
  40. %V%%R%23.11.82
  41. %V%%R%1.3.83
  42. %V%%R%1.6.83
  43. %V%%R%16.8.83
  44. %V%%R%22.11.83
  45. %V%%R%23.2.84
  46. %V%%R%23.5.84
  47. %V%%R%21.8.84
  48. %V%%R%21.11.84
  49. %V%%R%16.12.84
  50. %V%%R%16.12.84
  51. %V%%R%27.2.85
  52. %V%%R%28.5.85
  53. %V%%R%29.8.85
  54. %V%%R%25.11.85
  55. %V%%R%3.3.86
  56. %V%%R%28.5.86
  57. %V%%R%3.9.86
  58. %V%%R%24.11.86
  59. %V%%R%23.2.87
  60. %V%%R%22.5.87
  61. %V%%R%5.9.87
  62. %V%%R%25.11.87
  63. %V%%R%22.2.88
  64. %V%%R%24.5.88
  65. %V%%R%6.9.88
  66. %V%%R%21.11.88
  67. %V%%R%14.2.89
  68. %V%%R%24.5.89
  69. %V%%R%29.8.89
  70. %V%%R%22.11.89
  71. %V%%R%22.2.90
  72. %V%%R%23.5.90
  73. %CO:B,7,84%
  74.  
  75.  Day
  76.  Meter
  77.  
  78. %V%%R%%D0%602
  79. %V%%R%%D0%1211
  80. %V%%R%%D0%1838
  81. %V%%R%%D0%2470
  82. %V%%R%%D0%3174
  83. %V%%R%%D0%3932
  84. %V%%R%%D0%4581
  85. %V%%R%%D0%5201
  86. %V%%R%%D0%5921
  87. %V%%R%%D0%6852
  88. %V%%R%%D0%7641
  89. %V%%R%%D0%8288
  90. %V%%R%%D0%9052
  91. %V%%R%%D0%10029
  92. %V%%R%%D0%10737
  93. %V%%R%%D0%11328
  94. %V%%R%%D0%12067
  95. %V%%R%%D0%12953
  96. %V%%R%%D0%13732
  97. %V%%R%%D0%14554
  98. %V%%R%%D0%15436
  99. %V%%R%%D0%16516
  100. %V%%R%%D0%17187
  101. %V%%R%%D0%17957
  102. %V%%R%%D0%18705
  103. %V%%R%%D0%19655
  104. %V%%R%%D0%20345
  105. %V%%R%%D0%21046
  106. %V%%R%%D0%21866
  107. %V%%R%%D0%22754
  108. %V%%R%%D0%23488
  109. %V%%R%%D0%24155
  110. %V%%R%%D0%24840
  111. %V%%R%%D0%25624
  112. %V%%R%%D0%26223
  113. %V%%R%%D0%26823
  114. %V%%R%%D0%27561
  115. %V%%R%%D0%27825
  116. %V%%R%%D0%10
  117. %V%%R%%D0%474
  118. %V%%R%%D0%908
  119. %V%%R%%D0%1410
  120. %V%%R%%D0%2008
  121. %V%%R%%D0%2830
  122. %V%%R%%D0%3346
  123. %V%%R%%D0%3912
  124. %V%%R%%D0%4498
  125. %V%%R%%D0%5194
  126. %V%%R%%D0%5658
  127. %V%%R%%D0%6334
  128. %V%%R%%D0%6887
  129. %V%%R%%D0%7520
  130. %V%%R%%D0%7984
  131. %V%%R%%D0%8711
  132. %V%%R%%D0%9287
  133. %V%%R%%D0%9867
  134. %V%%R%%D0%10354
  135. %V%%R%%D0%11152
  136. %V%%R%%D0%11819
  137. %V%%R%%D0%12508
  138. %V%%R%%D0%13019
  139. %CO:C,6,77%
  140.  
  141. Day
  142. Units
  143.  
  144. %V%%R%%D0%0
  145. %V%%R%%D0%B7-B6
  146. %V%%R%%D0%B8-B7
  147. %V%%R%%D0%B9-B8
  148. %V%%R%%D0%B10-B9
  149. %V%%R%%D0%B11-B10
  150. %V%%R%%D0%B12-B11
  151. %V%%R%%D0%B13-B12
  152. %V%%R%%D0%B14-B13
  153. %V%%R%%D0%B15-B14
  154. %V%%R%%D0%B16-B15
  155. %V%%R%%D0%B17-B16
  156. %V%%R%%D0%B18-B17
  157. %V%%R%%D0%B19-B18
  158. %V%%R%%D0%B20-B19
  159. %V%%R%%D0%B21-B20
  160. %V%%R%%D0%B22-B21
  161. %V%%R%%D0%B23-B22
  162. %V%%R%%D0%B24-B23
  163. %V%%R%%D0%B25-B24
  164. %V%%R%%D0%B26-B25
  165. %V%%R%%D0%B27-B26
  166. %V%%R%%D0%B28-B27
  167. %V%%R%%D0%B29-B28
  168. %V%%R%%D0%B30-B29
  169. %V%%R%%D0%B31-B30
  170. %V%%R%%D0%B32-B31
  171. %V%%R%%D0%B33-B32
  172. %V%%R%%D0%B34-B33
  173. %V%%R%%D0%B35-B34
  174. %V%%R%%D0%B36-B35
  175. %V%%R%%D0%B37-B36
  176. %V%%R%%D0%B38-B37
  177. %V%%R%%D0%B39-B38
  178. %V%%R%%D0%B40-B39
  179. %V%%R%%D0%B41-B40
  180. %V%%R%%D0%B42-B41
  181. %V%%R%%D0%B43-B42
  182. %V%%R%%D0%0
  183. %V%%R%%D0%B45-B44
  184. %V%%R%%D0%B46-B45
  185. %V%%R%%D0%B47-B46
  186. %V%%R%%D0%B48-B47
  187. %V%%R%%D0%B49-B48
  188. %V%%R%%D0%B50-B49
  189. %V%%R%%D0%B51-B50
  190. %V%%R%%D0%B52-B51
  191. %V%%R%%D0%B53-B52
  192. %V%%R%%D0%B54-B53
  193. %V%%R%%D0%B55-B54
  194. %V%%R%%D0%B56-B55
  195. %V%%R%%D0%B57-B56
  196. %V%%R%%D0%B58-B57
  197. %V%%R%%D0%B59-B58
  198. %V%%R%%D0%B60-B59
  199. %V%%R%%D0%B61-B60
  200. %V%%R%%D0%B62-B61
  201. %V%%R%%D0%B63-B62
  202. %V%%R%%D0%B64-B63
  203. %V%%R%%D0%B65-B64
  204. %V%%R%%D0%B66-B65
  205. %CO:D,6,71%
  206.  
  207. Unit
  208. Cost
  209.  
  210. %V%%R%0
  211. %V%%R%%D3%vlookup(O7,[Elect_Rate]$A$3$A$28,1)
  212. %V%%R%%D3%vlookup(O8,[Elect_Rate]$A$3$A$28,1)
  213. %V%%R%%D3%vlookup(O9,[Elect_Rate]$A$3$A$28,1)
  214. %V%%R%%D3%vlookup(O10,[Elect_Rate]$A$3$A$28,1)
  215. %V%%R%%D3%vlookup(O11,[Elect_Rate]$A$3$A$28,1)
  216. %V%%R%%D3%vlookup(O12,[Elect_Rate]$A$3$A$28,1)
  217. %V%%R%%D3%vlookup(O13,[Elect_Rate]$A$3$A$28,1)
  218. %V%%R%%D3%vlookup(O14,[Elect_Rate]$A$3$A$28,1)
  219. %V%%R%%D3%vlookup(O15,[Elect_Rate]$A$3$A$28,1)
  220. %V%%R%%D3%vlookup(O16,[Elect_Rate]$A$3$A$28,1)
  221. %V%%R%%D3%vlookup(O17,[Elect_Rate]$A$3$A$28,1)
  222. %V%%R%%D3%vlookup(O18,[Elect_Rate]$A$3$A$28,1)
  223. %V%%R%%D3%vlookup(O19,[Elect_Rate]$A$3$A$28,1)
  224. %V%%R%%D3%vlookup(O20,[Elect_Rate]$A$3$A$28,1)
  225. %V%%R%%D3%vlookup(O21,[Elect_Rate]$A$3$A$28,1)
  226. %V%%R%%D3%vlookup(O22,[Elect_Rate]$A$3$A$28,1)
  227. %V%%R%%D3%vlookup(O23,[Elect_Rate]$A$3$A$28,1)
  228. %V%%R%%D3%vlookup(O24,[Elect_Rate]$A$3$A$28,1)
  229. %V%%R%%D3%vlookup(O25,[Elect_Rate]$A$3$A$28,1)
  230. %V%%R%%D3%vlookup(O26,[Elect_Rate]$A$3$A$28,1)
  231. %V%%R%%D3%vlookup(O27,[Elect_Rate]$A$3$A$28,1)
  232. %V%%R%%D3%vlookup(O28,[Elect_Rate]$A$3$A$28,1)
  233. %V%%R%%D3%vlookup(O29,[Elect_Rate]$A$3$A$28,1)
  234. %V%%R%%D3%vlookup(O30,[Elect_Rate]$A$3$A$28,1)
  235. %V%%R%%D3%vlookup(O31,[Elect_Rate]$A$3$A$28,1)
  236. %V%%R%%D3%vlookup(O32,[Elect_Rate]$A$3$A$28,1)
  237. %V%%R%%D3%vlookup(O33,[Elect_Rate]$A$3$A$28,1)
  238. %V%%R%%D3%vlookup(O34,[Elect_Rate]$A$3$A$28,1)
  239. %V%%R%%D3%vlookup(O35,[Elect_Rate]$A$3$A$28,1)
  240. %V%%R%%D3%vlookup(O36,[Elect_Rate]$A$3$A$28,1)
  241. %V%%R%%D3%vlookup(O37,[Elect_Rate]$A$3$A$28,1)
  242. %V%%R%%D3%vlookup(O38,[Elect_Rate]$A$3$A$28,1)
  243. %V%%R%%D3%vlookup(O39,[Elect_Rate]$A$3$A$28,1)
  244. %V%%R%%D3%vlookup(O40,[Elect_Rate]$A$3$A$28,1)
  245. %V%%R%%D3%vlookup(O41,[Elect_Rate]$A$3$A$28,1)
  246. %V%%R%%D3%vlookup(O42,[Elect_Rate]$A$3$A$28,1)
  247. %V%%R%%D3%vlookup(O43,[Elect_Rate]$A$3$A$28,1)
  248. New Meter
  249. %V%%R%%D3%vlookup(O45,[Elect_Rate]$A$3$A$28,1)
  250. %V%%R%%D3%vlookup(O46,[Elect_Rate]$A$3$A$28,1)
  251. %V%%R%%D3%vlookup(O47,[Elect_Rate]$A$3$A$28,1)
  252. %V%%R%%D3%vlookup(O48,[Elect_Rate]$A$3$A$28,1)
  253. %V%%R%%D3%vlookup(O49,[Elect_Rate]$A$3$A$28,1)
  254. %V%%R%%D3%vlookup(O50,[Elect_Rate]$A$3$A$28,1)
  255. %V%%R%%D3%vlookup(O51,[Elect_Rate]$A$3$A$28,1)
  256. %V%%R%%D3%vlookup(O52,[Elect_Rate]$A$3$A$28,1)
  257. %V%%R%%D3%vlookup(O53,[Elect_Rate]$A$3$A$28,1)
  258. %V%%R%%D3%vlookup(O54,[Elect_Rate]$A$3$A$28,1)
  259. %V%%R%%D3%vlookup(O55,[Elect_Rate]$A$3$A$28,1)
  260. %V%%R%%D3%vlookup(O56,[Elect_Rate]$A$3$A$28,1)
  261. %V%%R%%D3%vlookup(O57,[Elect_Rate]$A$3$A$28,1)
  262. %V%%R%%D3%vlookup(O58,[Elect_Rate]$A$3$A$28,1)
  263. %V%%R%%D3%vlookup(O59,[Elect_Rate]$A$3$A$28,1)
  264. %V%%R%%D3%vlookup(O60,[Elect_Rate]$A$3$A$28,1)
  265. %V%%R%%D3%vlookup(O61,[Elect_Rate]$A$3$A$28,1)
  266. %V%%R%%D3%vlookup(O62,[Elect_Rate]$A$3$A$28,1)
  267. %V%%R%%D3%vlookup(O63,[Elect_Rate]$A$3$A$28,1)
  268. %V%%R%%D3%vlookup(O64,[Elect_Rate]$A$3$A$28,1)
  269. %V%%R%%D3%vlookup(O65,[Elect_Rate]$A$3$A$28,1)
  270. %V%%R%%D3%vlookup(O66,[Elect_Rate]$A$3$A$28,1)
  271. %CO:E,6,65%
  272.  
  273. Day
  274. Amount
  275.  
  276. %V%%R%%D0%0
  277. %V%%R%%D2%int(C7*D7)/100
  278. %V%%R%%D2%int(C8*D8)/100
  279. %V%%R%%D2%int(C9*D9)/100
  280. %V%%R%%D2%int(C10*D10)/100
  281. %V%%R%%D2%int(C11*D11)/100
  282. %V%%R%%D2%int(C12*D12)/100
  283. %V%%R%%D2%int(C13*D13)/100
  284. %V%%R%%D2%int(C14*D14)/100
  285. %V%%R%%D2%int(C15*D15)/100
  286. %V%%R%%D2%int(C16*D16)/100
  287. %V%%R%%D2%int(C17*D17)/100
  288. %V%%R%%D2%int(C18*D18)/100
  289. %V%%R%%D2%int(C19*D19)/100
  290. %V%%R%%D2%int(C20*D20)/100
  291. %V%%R%%D2%int(C21*D21)/100
  292. %V%%R%%D2%int(C22*D22)/100
  293. %V%%R%%D2%int(C23*D23)/100
  294. %V%%R%%D2%int(C24*D24)/100
  295. %V%%R%%D2%int(C25*D25)/100
  296. %V%%R%%D2%int(C26*D26)/100
  297. %V%%R%%D2%int(C27*D27)/100
  298. %V%%R%%D2%int(C28*D28)/100
  299. %V%%R%%D2%int(C29*D29)/100
  300. %V%%R%%D2%int(C30*D30)/100
  301. %V%%R%%D2%int(C31*D31)/100
  302. %V%%R%%D2%int(C32*D32)/100
  303. %V%%R%%D2%int(C33*D33)/100
  304. %V%%R%%D2%int(C34*D34)/100
  305. %V%%R%%D2%int(C35*D35)/100
  306. %V%%R%%D2%int(C36*D36)/100
  307. %V%%R%%D2%int(C37*D37)/100
  308. %V%%R%%D2%int(C38*D38)/100
  309. %V%%R%%D2%int(C39*D39)/100
  310. %V%%R%%D2%int(C40*D40)/100
  311. %V%%R%%D2%int(C41*D41)/100
  312. %V%%R%%D2%int(C42*D42)/100
  313. %V%%R%%D2%int(C43*D43)/100
  314.  
  315. %V%%R%%D2%int(C45*D45)/100
  316. %V%%R%%D2%int(C46*D46)/100
  317. %V%%R%%D2%int(C47*D47)/100
  318. %V%%R%%D2%int(C48*D48)/100
  319. %V%%R%%D2%int(C49*D49)/100
  320. %V%%R%%D2%int(C50*D50)/100
  321. %V%%R%%D2%int(C51*D51)/100
  322. %V%%R%%D2%int(C52*D52)/100
  323. %V%%R%%D2%int(C53*D53)/100
  324. %V%%R%%D2%int(C54*D54)/100
  325. %V%%R%%D2%int(C55*D55)/100
  326. %V%%R%%D2%int(C56*D56)/100
  327. %V%%R%%D2%int(C57*D57)/100
  328. %V%%R%%D2%int(C58*D58)/100
  329. %V%%R%%D2%int(C59*D59)/100
  330. %V%%R%%D2%int(C60*D60)/100
  331. %V%%R%%D2%int(C61*D61)/100
  332. %V%%R%%D2%int(C62*D62)/100
  333. %V%%R%%D2%int(C63*D63)/100
  334. %V%%R%%D2%int(C64*D64)/100
  335. %V%%R%%D2%int(C65*D65)/100
  336. %V%%R%%D2%int(C66*D66)/100
  337. %CO:F,7,59%
  338.  
  339.  Night
  340.  Meter
  341.  
  342. %V%%R%%D0%0
  343. %V%%R%%D0%0
  344. %V%%R%%D0%0
  345. %V%%R%%D0%0
  346. %V%%R%%D0%0
  347. %V%%R%%D0%0
  348. %V%%R%%D0%0
  349. %V%%R%%D0%0
  350. %V%%R%%D0%0
  351. %V%%R%%D0%0
  352. %V%%R%%D0%0
  353. %V%%R%%D0%0
  354. %V%%R%%D0%0
  355. %V%%R%%D0%0
  356. %V%%R%%D0%0
  357. %V%%R%%D0%0
  358. %V%%R%%D0%0
  359. %V%%R%%D0%0
  360. %V%%R%%D0%0
  361. %V%%R%%D0%0
  362. %V%%R%%D0%0
  363. %V%%R%%D0%0
  364. %V%%R%%D0%0
  365. %V%%R%%D0%0
  366. %V%%R%%D0%0
  367. %V%%R%%D0%0
  368. %V%%R%%D0%0
  369. %V%%R%%D0%0
  370. %V%%R%%D0%0
  371. %V%%R%%D0%0
  372. %V%%R%%D0%0
  373. %V%%R%%D0%0
  374. %V%%R%%D0%0
  375. %V%%R%%D0%0
  376. %V%%R%%D0%0
  377. %V%%R%%D0%0
  378. %V%%R%%D0%0
  379. %V%%R%%D0%0
  380. %V%%R%%D0%20
  381. %V%%R%%D0%192
  382. %V%%R%%D0%391
  383. %V%%R%%D0%658
  384. %V%%R%%D0%1032
  385. %V%%R%%D0%1387
  386. %V%%R%%D0%1732
  387. %V%%R%%D0%2243
  388. %V%%R%%D0%2703
  389. %V%%R%%D0%3042
  390. %V%%R%%D0%3318
  391. %V%%R%%D0%4021
  392. %V%%R%%D0%4439
  393. %V%%R%%D0%4752
  394. %V%%R%%D0%5299
  395. %V%%R%%D0%5656
  396. %V%%R%%D0%6038
  397. %V%%R%%D0%6299
  398. %V%%R%%D0%6873
  399. %V%%R%%D0%7144
  400. %V%%R%%D0%7561
  401. %V%%R%%D0%7882
  402. %V%%R%%D0%8484
  403. %CO:G,6,52%
  404.  
  405. Night
  406. Units
  407.  
  408. %V%%R%%D0%0
  409. %V%%R%%D0%F7-F6
  410. %V%%R%%D0%F8-F7
  411. %V%%R%%D0%F9-F8
  412. %V%%R%%D0%F10-F9
  413. %V%%R%%D0%F11-F10
  414. %V%%R%%D0%F12-F11
  415. %V%%R%%D0%F13-F12
  416. %V%%R%%D0%F14-F13
  417. %V%%R%%D0%F15-F14
  418. %V%%R%%D0%F16-F15
  419. %V%%R%%D0%F17-F16
  420. %V%%R%%D0%F18-F17
  421. %V%%R%%D0%F19-F18
  422. %V%%R%%D0%F20-F19
  423. %V%%R%%D0%F21-F20
  424. %V%%R%%D0%F22-F21
  425. %V%%R%%D0%F23-F22
  426. %V%%R%%D0%F24-F23
  427. %V%%R%%D0%F25-F24
  428. %V%%R%%D0%F26-F25
  429. %V%%R%%D0%F27-F26
  430. %V%%R%%D0%F28-F27
  431. %V%%R%%D0%F29-F28
  432. %V%%R%%D0%F30-F29
  433. %V%%R%%D0%F31-F30
  434. %V%%R%%D0%F32-F31
  435. %V%%R%%D0%F33-F32
  436. %V%%R%%D0%F34-F33
  437. %V%%R%%D0%F35-F34
  438. %V%%R%%D0%F36-F35
  439. %V%%R%%D0%F37-F36
  440. %V%%R%%D0%F38-F37
  441. %V%%R%%D0%F39-F38
  442. %V%%R%%D0%F40-F39
  443. %V%%R%%D0%F41-F40
  444. %V%%R%%D0%F42-F41
  445. %V%%R%%D0%F43-F42
  446. %V%%R%%D0%0
  447. %V%%R%%D0%F45-F44
  448. %V%%R%%D0%F46-F45
  449. %V%%R%%D0%F47-F46
  450. %V%%R%%D0%F48-F47
  451. %V%%R%%D0%F49-F48
  452. %V%%R%%D0%F50-F49
  453. %V%%R%%D0%F51-F50
  454. %V%%R%%D0%F52-F51
  455. %V%%R%%D0%F53-F52
  456. %V%%R%%D0%F54-F53
  457. %V%%R%%D0%F55-F54
  458. %V%%R%%D0%F56-F55
  459. %V%%R%%D0%F57-F56
  460. %V%%R%%D0%F58-F57
  461. %V%%R%%D0%F59-F58
  462. %V%%R%%D0%F60-F59
  463. %V%%R%%D0%F61-F60
  464. %V%%R%%D0%F62-F61
  465. %V%%R%%D0%F63-F62
  466. %V%%R%%D0%F64-F63
  467. %V%%R%%D0%F65-F64
  468. %V%%R%%D0%F66-F65
  469. %CO:H,6,46%
  470.  
  471. Unit
  472. Cost
  473.  
  474. %V%%R%%D3%0
  475. %V%%R%%D3%vlookup(O7,[Elect_Rate]$A$3$A$28,3)
  476. %V%%R%%D3%vlookup(O8,[Elect_Rate]$A$3$A$28,3)
  477. %V%%R%%D3%vlookup(O9,[Elect_Rate]$A$3$A$28,3)
  478. %V%%R%%D3%vlookup(O10,[Elect_Rate]$A$3$A$28,3)
  479. %V%%R%%D3%vlookup(O11,[Elect_Rate]$A$3$A$28,3)
  480. %V%%R%%D3%vlookup(O12,[Elect_Rate]$A$3$A$28,3)
  481. %V%%R%%D3%vlookup(O13,[Elect_Rate]$A$3$A$28,3)
  482. %V%%R%%D3%vlookup(O14,[Elect_Rate]$A$3$A$28,3)
  483. %V%%R%%D3%vlookup(O15,[Elect_Rate]$A$3$A$28,3)
  484. %V%%R%%D3%vlookup(O16,[Elect_Rate]$A$3$A$28,3)
  485. %V%%R%%D3%vlookup(O17,[Elect_Rate]$A$3$A$28,3)
  486. %V%%R%%D3%vlookup(O18,[Elect_Rate]$A$3$A$28,3)
  487. %V%%R%%D3%vlookup(O19,[Elect_Rate]$A$3$A$28,3)
  488. %V%%R%%D3%vlookup(O20,[Elect_Rate]$A$3$A$28,3)
  489. %V%%R%%D3%vlookup(O21,[Elect_Rate]$A$3$A$28,3)
  490. %V%%R%%D3%vlookup(O22,[Elect_Rate]$A$3$A$28,3)
  491. %V%%R%%D3%vlookup(O23,[Elect_Rate]$A$3$A$28,3)
  492. %V%%R%%D3%vlookup(O24,[Elect_Rate]$A$3$A$28,3)
  493. %V%%R%%D3%vlookup(O25,[Elect_Rate]$A$3$A$28,3)
  494. %V%%R%%D3%vlookup(O26,[Elect_Rate]$A$3$A$28,3)
  495. %V%%R%%D3%vlookup(O27,[Elect_Rate]$A$3$A$28,3)
  496. %V%%R%%D3%vlookup(O28,[Elect_Rate]$A$3$A$28,3)
  497. %V%%R%%D3%vlookup(O29,[Elect_Rate]$A$3$A$28,3)
  498. %V%%R%%D3%vlookup(O30,[Elect_Rate]$A$3$A$28,3)
  499. %V%%R%%D3%vlookup(O31,[Elect_Rate]$A$3$A$28,3)
  500. %V%%R%%D3%vlookup(O32,[Elect_Rate]$A$3$A$28,3)
  501. %V%%R%%D3%vlookup(O33,[Elect_Rate]$A$3$A$28,3)
  502. %V%%R%%D3%vlookup(O34,[Elect_Rate]$A$3$A$28,3)
  503. %V%%R%%D3%vlookup(O35,[Elect_Rate]$A$3$A$28,3)
  504. %V%%R%%D3%vlookup(O36,[Elect_Rate]$A$3$A$28,3)
  505. %V%%R%%D3%vlookup(O37,[Elect_Rate]$A$3$A$28,3)
  506. %V%%R%%D3%vlookup(O38,[Elect_Rate]$A$3$A$28,3)
  507. %V%%R%%D3%vlookup(O39,[Elect_Rate]$A$3$A$28,3)
  508. %V%%R%%D3%vlookup(O40,[Elect_Rate]$A$3$A$28,3)
  509. %V%%R%%D3%vlookup(O41,[Elect_Rate]$A$3$A$28,3)
  510. %V%%R%%D3%vlookup(O42,[Elect_Rate]$A$3$A$28,3)
  511. %V%%R%%D3%vlookup(O43,[Elect_Rate]$A$3$A$28,3)
  512.  for Economy 7 
  513. %V%%R%%D3%vlookup(O45,[Elect_Rate]$A$3$A$28,3)
  514. %V%%R%%D3%vlookup(O46,[Elect_Rate]$A$3$A$28,3)
  515. %V%%R%%D3%vlookup(O47,[Elect_Rate]$A$3$A$28,3)
  516. %V%%R%%D3%vlookup(O48,[Elect_Rate]$A$3$A$28,3)
  517. %V%%R%%D3%vlookup(O49,[Elect_Rate]$A$3$A$28,3)
  518. %V%%R%%D3%vlookup(O50,[Elect_Rate]$A$3$A$28,3)
  519. %V%%R%%D3%vlookup(O51,[Elect_Rate]$A$3$A$28,3)
  520. %V%%R%%D3%vlookup(O52,[Elect_Rate]$A$3$A$28,3)
  521. %V%%R%%D3%vlookup(O53,[Elect_Rate]$A$3$A$28,3)
  522. %V%%R%%D3%vlookup(O54,[Elect_Rate]$A$3$A$28,3)
  523. %V%%R%%D3%vlookup(O55,[Elect_Rate]$A$3$A$28,3)
  524. %V%%R%%D3%vlookup(O56,[Elect_Rate]$A$3$A$28,3)
  525. %V%%R%%D3%vlookup(O57,[Elect_Rate]$A$3$A$28,3)
  526. %V%%R%%D3%vlookup(O58,[Elect_Rate]$A$3$A$28,3)
  527. %V%%R%%D3%vlookup(O59,[Elect_Rate]$A$3$A$28,3)
  528. %V%%R%%D3%vlookup(O60,[Elect_Rate]$A$3$A$28,3)
  529. %V%%R%%D3%vlookup(O61,[Elect_Rate]$A$3$A$28,3)
  530. %V%%R%%D3%vlookup(O62,[Elect_Rate]$A$3$A$28,3)
  531. %V%%R%%D3%vlookup(O63,[Elect_Rate]$A$3$A$28,3)
  532. %V%%R%%D3%vlookup(O64,[Elect_Rate]$A$3$A$28,3)
  533. %V%%R%%D3%vlookup(O65,[Elect_Rate]$A$3$A$28,3)
  534. %V%%R%%D3%vlookup(O66,[Elect_Rate]$A$3$A$28,3)
  535. %CO:I,6,40%
  536.  
  537. Night
  538. Amount
  539.  
  540. %V%%R%0
  541. %V%%R%int(G7*H7)/100
  542. %V%%R%int(G8*H8)/100
  543. %V%%R%int(G9*H9)/100
  544. %V%%R%int(G10*H10)/100
  545. %V%%R%int(G11*H11)/100
  546. %V%%R%int(G12*H12)/100
  547. %V%%R%int(G13*H13)/100
  548. %V%%R%int(G14*H14)/100
  549. %V%%R%int(G15*H15)/100
  550. %V%%R%int(G16*H16)/100
  551. %V%%R%int(G17*H17)/100
  552. %V%%R%int(G18*H18)/100
  553. %V%%R%int(G19*H19)/100
  554. %V%%R%int(G20*H20)/100
  555. %V%%R%int(G21*H21)/100
  556. %V%%R%int(G22*H22)/100
  557. %V%%R%int(G23*H23)/100
  558. %V%%R%int(G24*H24)/100
  559. %V%%R%int(G25*H25)/100
  560. %V%%R%int(G26*H26)/100
  561. %V%%R%int(G27*H27)/100
  562. %V%%R%int(G28*H28)/100
  563. %V%%R%int(G29*H29)/100
  564. %V%%R%int(G30*H30)/100
  565. %V%%R%int(G31*H31)/100
  566. %V%%R%int(G32*H32)/100
  567. %V%%R%int(G33*H33)/100
  568. %V%%R%int(G34*H34)/100
  569. %V%%R%int(G35*H35)/100
  570. %V%%R%int(G36*H36)/100
  571. %V%%R%int(G37*H37)/100
  572. %V%%R%int(G38*H38)/100
  573. %V%%R%int(G39*H39)/100
  574. %V%%R%int(G40*H40)/100
  575. %V%%R%int(G41*H41)/100
  576. %V%%R%int(G42*H42)/100
  577. %V%%R%int(G43*H43)/100
  578.  
  579. %V%%R%int(G45*H45)/100
  580. %V%%R%int(G46*H46)/100
  581. %V%%R%int(G47*H47)/100
  582. %V%%R%int(G48*H48)/100
  583. %V%%R%int(G49*H49)/100
  584. %V%%R%int(G50*H50)/100
  585. %V%%R%int(G51*H51)/100
  586. %V%%R%int(G52*H52)/100
  587. %V%%R%int(G53*H53)/100
  588. %V%%R%int(G54*H54)/100
  589. %V%%R%int(G55*H55)/100
  590. %V%%R%int(G56*H56)/100
  591. %V%%R%int(G57*H57)/100
  592. %V%%R%int(G58*H58)/100
  593. %V%%R%int(G59*H59)/100
  594. %V%%R%int(G60*H60)/100
  595. %V%%R%int(G61*H61)/100
  596. %V%%R%int(G62*H62)/100
  597. %V%%R%int(G63*H63)/100
  598. %V%%R%int(G64*H64)/100
  599. %V%%R%int(G65*H65)/100
  600. %V%%R%int(G66*H66)/100
  601. %CO:J,8,34%
  602.  
  603. Standing
  604.  Charge
  605.  
  606. %V%%R%0
  607. %V%%R%vlookup(O7,[Elect_Rate]$A$3$A$28,2)
  608. %V%%R%vlookup(O8,[Elect_Rate]$A$3$A$28,2)
  609. %V%%R%vlookup(O9,[Elect_Rate]$A$3$A$28,2)
  610. %V%%R%vlookup(O10,[Elect_Rate]$A$3$A$28,2)
  611. %V%%R%vlookup(O11,[Elect_Rate]$A$3$A$28,2)
  612. %V%%R%vlookup(O12,[Elect_Rate]$A$3$A$28,2)
  613. %V%%R%vlookup(O13,[Elect_Rate]$A$3$A$28,2)
  614. %V%%R%vlookup(O14,[Elect_Rate]$A$3$A$28,2)
  615. %V%%R%vlookup(O15,[Elect_Rate]$A$3$A$28,2)
  616. %V%%R%vlookup(O16,[Elect_Rate]$A$3$A$28,2)
  617. %V%%R%vlookup(O17,[Elect_Rate]$A$3$A$28,2)
  618. %V%%R%vlookup(O18,[Elect_Rate]$A$3$A$28,2)
  619. %V%%R%vlookup(O19,[Elect_Rate]$A$3$A$28,2)
  620. %V%%R%vlookup(O20,[Elect_Rate]$A$3$A$28,2)
  621. %V%%R%vlookup(O21,[Elect_Rate]$A$3$A$28,2)
  622. %V%%R%vlookup(O22,[Elect_Rate]$A$3$A$28,2)
  623. %V%%R%vlookup(O23,[Elect_Rate]$A$3$A$28,2)
  624. %V%%R%vlookup(O24,[Elect_Rate]$A$3$A$28,2)
  625. %V%%R%vlookup(O25,[Elect_Rate]$A$3$A$28,2)
  626. %V%%R%vlookup(O26,[Elect_Rate]$A$3$A$28,2)
  627. %V%%R%vlookup(O27,[Elect_Rate]$A$3$A$28,2)
  628. %V%%R%vlookup(O28,[Elect_Rate]$A$3$A$28,2)
  629. %V%%R%vlookup(O29,[Elect_Rate]$A$3$A$28,2)
  630. %V%%R%vlookup(O30,[Elect_Rate]$A$3$A$28,2)
  631. %V%%R%vlookup(O31,[Elect_Rate]$A$3$A$28,2)
  632. %V%%R%vlookup(O32,[Elect_Rate]$A$3$A$28,2)
  633. %V%%R%vlookup(O33,[Elect_Rate]$A$3$A$28,2)
  634. %V%%R%vlookup(O34,[Elect_Rate]$A$3$A$28,2)
  635. %V%%R%vlookup(O35,[Elect_Rate]$A$3$A$28,2)
  636. %V%%R%vlookup(O36,[Elect_Rate]$A$3$A$28,2)
  637. %V%%R%vlookup(O37,[Elect_Rate]$A$3$A$28,2)
  638. %V%%R%vlookup(O38,[Elect_Rate]$A$3$A$28,2)
  639. %V%%R%vlookup(O39,[Elect_Rate]$A$3$A$28,2)
  640. %V%%R%vlookup(O40,[Elect_Rate]$A$3$A$28,2)
  641. %V%%R%vlookup(O41,[Elect_Rate]$A$3$A$28,2)
  642. %V%%R%vlookup(O42,[Elect_Rate]$A$3$A$28,2)
  643. %V%%R%vlookup(O43,[Elect_Rate]$A$3$A$28,2)
  644.  
  645. %V%%R%vlookup(O45,[Elect_Rate]$A$3$A$28,2)
  646. %V%%R%vlookup(O46,[Elect_Rate]$A$3$A$28,2)
  647. %V%%R%vlookup(O47,[Elect_Rate]$A$3$A$28,2)
  648. %V%%R%vlookup(O48,[Elect_Rate]$A$3$A$28,2)
  649. %V%%R%vlookup(O49,[Elect_Rate]$A$3$A$28,2)
  650. %V%%R%vlookup(O50,[Elect_Rate]$A$3$A$28,2)
  651. %V%%R%vlookup(O51,[Elect_Rate]$A$3$A$28,2)
  652. %V%%R%vlookup(O52,[Elect_Rate]$A$3$A$28,2)
  653. %V%%R%vlookup(O53,[Elect_Rate]$A$3$A$28,2)
  654. %V%%R%vlookup(O54,[Elect_Rate]$A$3$A$28,2)
  655. %V%%R%vlookup(O55,[Elect_Rate]$A$3$A$28,2)
  656. %V%%R%vlookup(O56,[Elect_Rate]$A$3$A$28,2)
  657. %V%%R%vlookup(O57,[Elect_Rate]$A$3$A$28,2)
  658. %V%%R%vlookup(O58,[Elect_Rate]$A$3$A$28,2)
  659. %V%%R%vlookup(O59,[Elect_Rate]$A$3$A$28,2)
  660. %V%%R%vlookup(O60,[Elect_Rate]$A$3$A$28,2)
  661. %V%%R%vlookup(O61,[Elect_Rate]$A$3$A$28,2)
  662. %V%%R%vlookup(O62,[Elect_Rate]$A$3$A$28,2)
  663. %V%%R%vlookup(O63,[Elect_Rate]$A$3$A$28,2)
  664. %V%%R%vlookup(O64,[Elect_Rate]$A$3$A$28,2)
  665. %V%%R%vlookup(O65,[Elect_Rate]$A$3$A$28,2)
  666. %V%%R%vlookup(O66,[Elect_Rate]$A$3$A$28,2)
  667. %CO:K,7,26%
  668.  
  669.  
  670.  Extras
  671.  
  672. %V%%R%0
  673. %V%%R%0.85
  674. %V%%R%1.09
  675. %V%%R%0
  676. %V%%R%0
  677. %V%%R%0
  678. %V%%R%0
  679. %V%%R%0
  680. %V%%R%0
  681. %V%%R%0
  682. %V%%R%0
  683. %V%%R%0
  684. %V%%R%0
  685. %V%%R%0
  686. %V%%R%0
  687. %V%%R%0
  688. %V%%R%0
  689. %V%%R%0
  690. %V%%R%0
  691. %V%%R%0
  692. %V%%R%0
  693. %V%%R%0
  694. %V%%R%0
  695. %V%%R%0
  696. %V%%R%0
  697. %V%%R%0
  698. %V%%R%0
  699. %V%%R%0
  700. %V%%R%0
  701. %V%%R%0
  702. %V%%R%0
  703. %V%%R%0
  704. %V%%R%0
  705. %V%%R%0
  706. %V%%R%0
  707. %V%%R%0
  708. %V%%R%0
  709. %V%%R%0
  710.  
  711. %V%%R%0
  712. %V%%R%0
  713. %V%%R%0
  714. %V%%R%0
  715. %V%%R%0
  716. %V%%R%0
  717. %V%%R%-2.15
  718. %V%%R%-2.09
  719. %V%%R%0
  720. %V%%R%0
  721. %V%%R%0
  722. %V%%R%0
  723. %V%%R%0
  724. %V%%R%0
  725. %V%%R%0
  726. %V%%R%0
  727. %V%%R%0
  728. %V%%R%0
  729. %V%%R%0
  730. %V%%R%0
  731. %V%%R%0
  732. %V%%R%0
  733. %CO:L,7,19%
  734.  
  735.  Total
  736.  Charge
  737.  
  738. %V%%R%0
  739. %V%%R%E7+I7+K7+J7
  740. %V%%R%E8+I8+J8+K8
  741. %V%%R%E9+I9+J9+K9
  742. %V%%R%E10+I10+J10+K10
  743. %V%%R%E11+I11+J11+K11
  744. %V%%R%E12+I12+J12+K12
  745. %V%%R%E13+I13+J13+K13
  746. %V%%R%E14+I14+J14+K14
  747. %V%%R%E15+I15+J15+K15
  748. %V%%R%E16+I16+J16+K16
  749. %V%%R%E17+I17+J17+K17
  750. %V%%R%E18+I18+J18+K18
  751. %V%%R%E19+I19+J19+K19
  752. %V%%R%E20+I20+J20+K20
  753. %V%%R%E21+I21+J21+K21
  754. %V%%R%E22+I22+J22+K22
  755. %V%%R%E23+I23+J23+K23
  756. %V%%R%E24+I24+J24+K24
  757. %V%%R%E25+I25+J25+K25
  758. %V%%R%E26+I26+J26+K26
  759. %V%%R%E27+I27+J27+K27
  760. %V%%R%E28+I28+J28+K28
  761. %V%%R%E29+I29+J29+K29
  762. %V%%R%E30+I30+J30+K30
  763. %V%%R%E31+I31+J31+K31
  764. %V%%R%E32+I32+J32+K32
  765. %V%%R%E33+I33+J33+K33
  766. %V%%R%E34+I34+J34+K34
  767. %V%%R%E35+I35+J35+K35
  768. %V%%R%E36+I36+J36+K36
  769. %V%%R%E37+I37+J37+K37
  770. %V%%R%E38+I38+J38+K38
  771. %V%%R%E39+I39+J39+K39
  772. %V%%R%E40+I40+J40+K40
  773. %V%%R%E41+I41+J41+K41
  774. %V%%R%E42+I42+J42+K42
  775. %V%%R%E43+I43+J43+K43
  776. %V%%R%E44+I44+J44+K44
  777. %V%%R%E45+I45+J45+K45
  778. %V%%R%E46+I46+J46+K46
  779. %V%%R%E47+I47+J47+K47
  780. %V%%R%E48+I48+J48+K48
  781. %V%%R%E49+I49+J49+K49
  782. %V%%R%E50+I50+J50+K50
  783. %V%%R%E51+I51+J51+K51
  784. %V%%R%E52+I52+J52+K52
  785. %V%%R%E53+I53+J53+K53
  786. %V%%R%E54+I54+J54+K54
  787. %V%%R%E55+I55+J55+K55
  788. %V%%R%E56+I56+J56+K56
  789. %V%%R%E57+I57+J57+K57
  790. %V%%R%E58+I58+J58+K58
  791. %V%%R%E59+I59+J59+K59
  792. %V%%R%E60+I60+J60+K60
  793. %V%%R%E61+I61+J61+K61
  794. %V%%R%E62+I62+J62+K62
  795. %V%%R%E63+I63+J63+K63
  796. %V%%R%E64+I64+J64+K64
  797. %V%%R%E65+I65+J65+K65
  798. %V%%R%E66+I66+J66+K66
  799. %CO:M,7,12%
  800.  
  801.  Annual
  802.  Usage
  803.  
  804. %V%%R%%D0%0
  805.  
  806.  
  807.  
  808. %V%%R%%D0%(B10-B6)+(F10-F6)
  809.  
  810.  
  811.  
  812. %V%%R%%D0%(B14-B10)+(F14-F10)
  813.  
  814.  
  815.  
  816. %V%%R%%D0%(B18-B14)+(F18-F14)
  817.  
  818.  
  819.  
  820. %V%%R%%D0%(B22-B18)+(F22-F18)
  821.  
  822.  
  823.  
  824. %V%%R%%D0%(B26-B22)+(F26-F22)
  825.  
  826.  
  827.  
  828. %V%%R%%D0%(B30-B26)+(F30-F26)
  829.  
  830.  
  831.  
  832. %V%%R%%D0%(B34-B30)+(F34-F30)
  833.  
  834.  
  835.  
  836. %V%%R%%D0%(B38-B34)+(F38-F34)
  837.  
  838.  
  839.  
  840.  
  841. %V%%R%%D0%(B43-B38)+(F43-F38)
  842.  
  843.  
  844.  
  845.  
  846. %V%%R%%D0%(B48-B44)+(F48-F44)
  847.  
  848.  
  849.  
  850. %V%%R%%D0%(B52-B48)+(F52-F48)
  851.  
  852.  
  853.  
  854. %V%%R%%D0%(B56-B52)+(F56-F52)
  855.  
  856.  
  857.  
  858. %V%%R%%D0%(B60-B56)+(F60-F56)
  859.  
  860.  
  861.  
  862. %V%%R%%D0%(B64-B60)+(F64-F60)
  863. %CO:N,5,5%
  864.  
  865.  
  866. Year
  867.  
  868. %V%%R%%D0%1975
  869.  
  870.  
  871.  
  872. %V%%R%%D0%N6+1
  873.  
  874.  
  875.  
  876. %V%%R%%D0%N10+1
  877.  
  878.  
  879.  
  880. %V%%R%%D0%N14+1
  881.  
  882.  
  883.  
  884. %V%%R%%D0%N18+1
  885.  
  886.  
  887.  
  888. %V%%R%%D0%N22+1
  889.  
  890.  
  891.  
  892. %V%%R%%D0%N26+1
  893.  
  894.  
  895.  
  896. %V%%R%%D0%N30+1
  897.  
  898.  
  899.  
  900. %V%%R%%D0%N34+1
  901.  
  902.  
  903.  
  904.  
  905. %V%%R%%D0%N38+1
  906.  
  907.  
  908.  
  909.  
  910. %V%%R%%D0%N43+1
  911.  
  912.  
  913.  
  914. %V%%R%%D0%N48+1
  915.  
  916.  
  917.  
  918. %V%%R%%D0%N52+1
  919.  
  920.  
  921.  
  922. %V%%R%%D0%N56+1
  923.  
  924.  
  925.  
  926. %V%%R%%D0%N60+1
  927. %CO:O,12,0%
  928.  
  929.  
  930.  
  931.  
  932. %V%%R%%D0%(year(A6))*10000+(month(A6))*100+(day(A6))
  933. %V%%R%%D0%(year(A7))*10000+(month(A7))*100+(day(A7))
  934. %V%%R%%D0%(year(A8))*10000+(month(A8))*100+(day(A8))
  935. %V%%R%%D0%(year(A9))*10000+(month(A9))*100+(day(A9))
  936. %V%%R%%D0%(year(A10))*10000+(month(A10))*100+(day(A10))
  937. %V%%R%%D0%(year(A11))*10000+(month(A11))*100+(day(A11))
  938. %V%%R%%D0%(year(A12))*10000+(month(A12))*100+(day(A12))
  939. %V%%R%%D0%(year(A13))*10000+(month(A13))*100+(day(A13))
  940. %V%%R%%D0%(year(A14))*10000+(month(A14))*100+(day(A14))
  941. %V%%R%%D0%(year(A15))*10000+(month(A15))*100+(day(A15))
  942. %V%%R%%D0%(year(A16))*10000+(month(A16))*100+(day(A16))
  943. %V%%R%%D0%(year(A17))*10000+(month(A17))*100+(day(A17))
  944. %V%%R%%D0%(year(A18))*10000+(month(A18))*100+(day(A18))
  945. %V%%R%%D0%(year(A19))*10000+(month(A19))*100+(day(A19))
  946. %V%%R%%D0%(year(A20))*10000+(month(A20))*100+(day(A20))
  947. %V%%R%%D0%(year(A21))*10000+(month(A21))*100+(day(A21))
  948. %V%%R%%D0%(year(A22))*10000+(month(A22))*100+(day(A22))
  949. %V%%R%%D0%(year(A23))*10000+(month(A23))*100+(day(A23))
  950. %V%%R%%D0%(year(A24))*10000+(month(A24))*100+(day(A24))
  951. %V%%R%%D0%(year(A25))*10000+(month(A25))*100+(day(A25))
  952. %V%%R%%D0%(year(A26))*10000+(month(A26))*100+(day(A26))
  953. %V%%R%%D0%(year(A27))*10000+(month(A27))*100+(day(A27))
  954. %V%%R%%D0%(year(A28))*10000+(month(A28))*100+(day(A28))
  955. %V%%R%%D0%(year(A29))*10000+(month(A29))*100+(day(A29))
  956. %V%%R%%D0%(year(A30))*10000+(month(A30))*100+(day(A30))
  957. %V%%R%%D0%(year(A31))*10000+(month(A31))*100+(day(A31))
  958. %V%%R%%D0%(year(A32))*10000+(month(A32))*100+(day(A32))
  959. %V%%R%%D0%(year(A33))*10000+(month(A33))*100+(day(A33))
  960. %V%%R%%D0%(year(A34))*10000+(month(A34))*100+(day(A34))
  961. %V%%R%%D0%(year(A35))*10000+(month(A35))*100+(day(A35))
  962. %V%%R%%D0%(year(A36))*10000+(month(A36))*100+(day(A36))
  963. %V%%R%%D0%(year(A37))*10000+(month(A37))*100+(day(A37))
  964. %V%%R%%D0%(year(A38))*10000+(month(A38))*100+(day(A38))
  965. %V%%R%%D0%(year(A39))*10000+(month(A39))*100+(day(A39))
  966. %V%%R%%D0%(year(A40))*10000+(month(A40))*100+(day(A40))
  967. %V%%R%%D0%(year(A41))*10000+(month(A41))*100+(day(A41))
  968. %V%%R%%D0%(year(A42))*10000+(month(A42))*100+(day(A42))
  969. %V%%R%%D0%(year(A43))*10000+(month(A43))*100+(day(A43))
  970. %V%%R%%D0%(year(A44))*10000+(month(A44))*100+(day(A44))
  971. %V%%R%%D0%(year(A45))*10000+(month(A45))*100+(day(A45))
  972. %V%%R%%D0%(year(A46))*10000+(month(A46))*100+(day(A46))
  973. %V%%R%%D0%(year(A47))*10000+(month(A47))*100+(day(A47))
  974. %V%%R%%D0%(year(A48))*10000+(month(A48))*100+(day(A48))
  975. %V%%R%%D0%(year(A49))*10000+(month(A49))*100+(day(A49))
  976. %V%%R%%D0%(year(A50))*10000+(month(A50))*100+(day(A50))
  977. %V%%R%%D0%(year(A51))*10000+(month(A51))*100+(day(A51))
  978. %V%%R%%D0%(year(A52))*10000+(month(A52))*100+(day(A52))
  979. %V%%R%%D0%(year(A53))*10000+(month(A53))*100+(day(A53))
  980. %V%%R%%D0%(year(A54))*10000+(month(A54))*100+(day(A54))
  981. %V%%R%%D0%(year(A55))*10000+(month(A55))*100+(day(A55))
  982. %V%%R%%D0%(year(A56))*10000+(month(A56))*100+(day(A56))
  983. %V%%R%%D0%(year(A57))*10000+(month(A57))*100+(day(A57))
  984. %V%%R%%D0%(year(A58))*10000+(month(A58))*100+(day(A58))
  985. %V%%R%%D0%(year(A59))*10000+(month(A59))*100+(day(A59))
  986. %V%%R%%D0%(year(A60))*10000+(month(A60))*100+(day(A60))
  987. %V%%R%%D0%(year(A61))*10000+(month(A61))*100+(day(A61))
  988. %V%%R%%D0%(year(A62))*10000+(month(A62))*100+(day(A62))
  989. %V%%R%%D0%(year(A63))*10000+(month(A63))*100+(day(A63))
  990. %V%%R%%D0%(year(A64))*10000+(month(A64))*100+(day(A64))
  991. %V%%R%%D0%(year(A65))*10000+(month(A65))*100+(day(A65))
  992. %V%%R%%D0%(year(A66))*10000+(month(A66))*100+(day(A66))
  993.